﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetVehiculoalquiladoByID')
	BEGIN
		DROP  Procedure  GetVehiculoalquiladoByID
	END

GO

CREATE Procedure GetVehiculoalquiladoByID

	(
		@idVehiculoAlquilado int
	)

AS

BEGIN
	SET NOCOUNT ON
	
	SELECT
	VA.[Contrato],
	VA.[IdBien],
	VA.[IdVehiculoAlquilado],
	VA.[MontoPago]
	FROM [VehiculoAlquilado] AS VA
	WHERE VA.[IdVehiculoAlquilado] = @idVehiculoAlquilado

	SET NOCOUNT OFF
END

GO


GRANT EXEC ON GetVehiculoalquiladoByID TO PUBLIC

GO


